<?php
$con = mysql_connect("localhost",'root','SONG742774011xin') or die('error:'.mysql_error());
mysql_select_db('users',$con) or die('error:'.mysql_error());
mysql_query('set NAMES utf8');
    //建表

mysql_select_db("ecshop",$con);
$sql = "CREATE TABLE teacher_list
(
`teacher_id` mediumint(8) unsigned NOT NULL auto_increment PRIMARY KEY ,
`teacher_name` varchar(20) NOT NULL default '',
`age` smallint(5) unsigned NOT NULL default '0',
'sex' tinyint(1) NOT null

)";
mysql_query($sql,$con);

mysql_close($con);
?>

/**
 * Created by PhpStorm.
 * User: tuhao
 * Date: 2016/9/29
 * Time: 9:10
 */